package online.helloup.text_blocks;

public class P01_Creating_a_multiline {


    /*
    UPDATE "public"."office"
    SET ("address_first", "address_second", "phone") =
            (SELECT "public"."employee"."first_name",
            "public"."employee"."last_name", ?
    FROM "public"."employee"
    WHERE "public"."employee"."job_title" = ?
    */
    public static void main(String[] args) {

        //step01: JDK 8之前的第一种方式 纯字符串拼接
        String sql="UPDATE \"public\".\"office\" \n " +
                "    SET (\"address_first\", \"address_second\", \"phone\") =\n" +
                "            (SELECT \"public\".\"employee\".\"first_name\",\n" +
                "            \"public\".\"employee\".\"last_name\", ?\n" +
                "    FROM \"public\".\"employee\"\n" +
                "    WHERE \"public\".\"employee\".\"job_title\" = ?";
        System.out.println(sql);


    }
}
